UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8cCKFKujUnOS4OajQq7/HbW4xtDcIqfnTTle19HRjw='
WHERE
key_id = '0217e0965c8c1f5f3a7ebb44c19c8849530f01d8478a490ef47e46a212bfbc2e'
AND (
token = '/8cCKFKujUnOS4OajQq7/HbW4xtDcIqfnTTle19HRjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)