UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QP26hG5QKbWQJBOz/zF3zUp4QAQOUt/kRjzenJeGxMA='
WHERE
key_id = '2d39ecff232c7a86f31be58f5c123a7eab0ab6b58c8a1edaa7063669c49ae22c'
AND (
token = 'QP26hG5QKbWQJBOz/zF3zUp4QAQOUt/kRjzenJeGxMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)