UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNGl2EOwlNKvQ4cK8rxAvPe/UZJYGajiprddA2FX0uQ='
WHERE
key_id = '9b583385e39de820831a57c5a857d65b55b9a6d559cc452fa976cdb0c79c0004'
AND (
token = 'CNGl2EOwlNKvQ4cK8rxAvPe/UZJYGajiprddA2FX0uQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)