UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HaHKQsogk8Q/uel24SFQaDaOZtZHqHHo8gPbRYUYxU='
WHERE
key_id = '5a86a486728738b6e0e3aefced7d42dce7a6f6b6b1fd95883aebc24bf11484a2'
AND (
token = '3HaHKQsogk8Q/uel24SFQaDaOZtZHqHHo8gPbRYUYxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)