UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQER7WNbVEYzqVmkhIzkNRwAB2P19d/D9DMTOOxhYY8='
WHERE
key_id = '149109c53b7dcb51f17a83379a96ccd1986f16783192bab600ae94309936205f'
AND (
token = 'lQER7WNbVEYzqVmkhIzkNRwAB2P19d/D9DMTOOxhYY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)