UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jhPOhPXZljuCM8+gvZ6eIbdNg0P8CrqZfYRHYX4NFuM='
WHERE
key_id = 'b97c30ea5c590a34441611bee0f880f382388ff2231598c6f6eeae3c7d86fe0e'
AND (
token = 'jhPOhPXZljuCM8+gvZ6eIbdNg0P8CrqZfYRHYX4NFuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)