UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XQvQF7f0+I+oOBIaPS22Jhql3vrIHcoPmItNuaPevY='
WHERE
key_id = 'cb97884f4208030826581ab3ab60e0469ce919caa0d33e37e64b7b65d4921a1e'
AND (
token = '5XQvQF7f0+I+oOBIaPS22Jhql3vrIHcoPmItNuaPevY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)