UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDdNTzUlL0DydghIYV94YN+9n/ts/+pznwJt0c+gllQ='
WHERE
key_id = 'ea89e3d4e9a07dc23d147404d4ee2b48c7df99c88a9ec97d945e6dc36930c748'
AND (
token = 'mDdNTzUlL0DydghIYV94YN+9n/ts/+pznwJt0c+gllQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)