UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8yuMHGM5rWxIqEC/DBIERctkQiqB60jjIoUs3jX6kM='
WHERE
key_id = '05631f445bb548a6d0153d76075c049be76a23e079976ae865ccf80fa14d57fd'
AND (
token = 'v8yuMHGM5rWxIqEC/DBIERctkQiqB60jjIoUs3jX6kM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)