UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UktqDO6UEYEpe4pv9XPHdfbkfImf7XA7MDYrpwmqgw='
WHERE
key_id = 'e9ab4e0852f9333ce2f4b5cc3bf046cacb33bffdb4698d12cd3cb165fb874bc3'
AND (
token = '9UktqDO6UEYEpe4pv9XPHdfbkfImf7XA7MDYrpwmqgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)