UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8PQRm+fTia04AWYey5LhRmQ+LCOVMdlG5D3Bpjptrs='
WHERE
key_id = 'dc547c90c101614598beda143d68c33f1c9ee40fd182820ff51acfd313c5de65'
AND (
token = 'c8PQRm+fTia04AWYey5LhRmQ+LCOVMdlG5D3Bpjptrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)