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