UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CLM4Q7x9kI/hicOXNUusfqWkm9t+L/U6sYCBPjYgXV8='
WHERE
key_id = '1888a60ab424324ac78e10fa9d0bf3f68e6c2df336681afe5c19aae2bc1096af'
AND (
token = 'CLM4Q7x9kI/hicOXNUusfqWkm9t+L/U6sYCBPjYgXV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)