UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xakmqVsn9bGYTL7TRI+oucIGjDu7J7tqpL7kdxnQWgw='
WHERE
key_id = '431b87a7932e222965a6092561c726a4918948080ebb438005f34fec8b34381d'
AND (
token = 'xakmqVsn9bGYTL7TRI+oucIGjDu7J7tqpL7kdxnQWgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)