UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRoJgp6NWeJE5SnzKE6jMbR8TlkW2cOZN7LfsuPuWn8='
WHERE
key_id = '5774d297f50d07aa7a0a701f531a0806f0e98e1c49998c84a0bbf2a8d2d53d11'
AND (
token = 'BRoJgp6NWeJE5SnzKE6jMbR8TlkW2cOZN7LfsuPuWn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)