UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZ3d8FlC3bXbS5Sr1uRyqLPehUDzLLewNXOAAWrB9Ek='
WHERE
key_id = 'd582d4be03f9c363878115a28dd0a63b5506f5a2035b8fa6de0d7d50fd574e5a'
AND (
token = 'WZ3d8FlC3bXbS5Sr1uRyqLPehUDzLLewNXOAAWrB9Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)