UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hA2c7pJy3Qwlr3WyvisSp9fCzjEswIVUuRhzQXekdTM='
WHERE
key_id = '47a54758b0d19ea166acd12e98aa468bfd31065c9424a442fc2acbc155715b83'
AND (
token = 'hA2c7pJy3Qwlr3WyvisSp9fCzjEswIVUuRhzQXekdTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)