UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mwSpJiXzZBpRnhPdD60cK/eJoAC/EfnxiHgv0Rpccrk='
WHERE
key_id = '77efc5423791ca10507385728db21580055d9babe9cf1fd96ec41ec1f19e57a7'
AND (
token = 'mwSpJiXzZBpRnhPdD60cK/eJoAC/EfnxiHgv0Rpccrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)