UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qHTE8Xk0NMbx6Duir/vas01a81kSZKssyr5wJZCGVY='
WHERE
key_id = '5f1f7af3d909a5119941e25c6bfbad8b7f34d1f31e6aa150afe55c569f7946f6'
AND (
token = '8qHTE8Xk0NMbx6Duir/vas01a81kSZKssyr5wJZCGVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)