UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwwhN7Lb8fGTy022WKYu0lkqUz2PE54NVqeDTM4a0H4='
WHERE
key_id = 'c9c18da60896dfd61f6f150119278e880e572c90676d430de4124d52690e94fa'
AND (
token = 'NwwhN7Lb8fGTy022WKYu0lkqUz2PE54NVqeDTM4a0H4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)