UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foLyLKiBbsAffSQ7mGQYNNOEgXJFFrIrhUMQHo4gVms='
WHERE
key_id = 'a7a9466cf1e63450d0375f48b8c0bdcda0466e1982f15e3c957d80d01d043531'
AND (
token = 'foLyLKiBbsAffSQ7mGQYNNOEgXJFFrIrhUMQHo4gVms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)