UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKTLLSnWUD9K2YH+VQuWF/H7/Zvvc7e5HLb3QupHUj8='
WHERE
key_id = 'ce47915e63fe36ff4e4640c58b73d5d754cbc3dab06897b9b8231ebfb6b56820'
AND (
token = 'vKTLLSnWUD9K2YH+VQuWF/H7/Zvvc7e5HLb3QupHUj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)