UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sVVzvs88vjNj6HNqS85g1eB2Dn9RvXVai2EHaK4yos8='
WHERE
key_id = '31a429dbf1368ef0e57cb536703bd16b0d41dcebbe46ce45aad8026c5a2a1787'
AND (
token = 'sVVzvs88vjNj6HNqS85g1eB2Dn9RvXVai2EHaK4yos8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)