UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xw+qlcw9c7PtpNn2Hf5oh5fX8z/HqBXfEmtswQUYZY4='
WHERE
key_id = '4e8cba830f73e65a0b230df092cb1c2bd5e8bbcb34aef0b0f8f43448dd41f592'
AND (
token = 'Xw+qlcw9c7PtpNn2Hf5oh5fX8z/HqBXfEmtswQUYZY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)