UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X717j+NCqIkutnhQrTlUxMMZXTTY6CFMP5kfxtkKdVg='
WHERE
key_id = '661749f6189f08d1e3e463d8fa5a7c9abc2cb22bc5fc985930615361b07eab38'
AND (
token = 'X717j+NCqIkutnhQrTlUxMMZXTTY6CFMP5kfxtkKdVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)