UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imQsqP8uk4vm/D63PvnrUA0Lb4OyaQdmFMVQPGKBA88='
WHERE
key_id = '565b9feff53ea9440bf8d6545b719178cb7dc176e266efe879bc2b0d42576973'
AND (
token = 'imQsqP8uk4vm/D63PvnrUA0Lb4OyaQdmFMVQPGKBA88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)