UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIJKjVVZkXWKSWV010gqUXJ8BpSSR7NhwJ8GnHT7jl8='
WHERE
key_id = '97b9e8d213d5100c9b4646c7b634e5ee410dbc3310c3600c915a602f3a6b37cf'
AND (
token = 'hIJKjVVZkXWKSWV010gqUXJ8BpSSR7NhwJ8GnHT7jl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)