UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WbslHw9Hi4EOWE7Vcu0nAilOVIFcenc7kO2vRki780='
WHERE
key_id = 'c98e0e564b72e49493991bb9281f1d1177ca1107edb051eca033e9505054cfef'
AND (
token = '7WbslHw9Hi4EOWE7Vcu0nAilOVIFcenc7kO2vRki780='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)