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