UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0H73fKa0JhZmErAd5Lf/xTcXFWSDQaJX1A0bZHRSoU='
WHERE
key_id = 'eb7129e3627731d0a92bdc678e6e9982b7bd44389733b5d78e133d412dbd7fd8'
AND (
token = 'p0H73fKa0JhZmErAd5Lf/xTcXFWSDQaJX1A0bZHRSoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)