UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+ClSVCFVo7rqJ8Kfifema1w7VYPtDLCSOo9V016Kzk='
WHERE
key_id = 'ea4e89d0224a7df76e7a8dfca32528bdb650aa28a73a2087fc4f07582f3da836'
AND (
token = '6+ClSVCFVo7rqJ8Kfifema1w7VYPtDLCSOo9V016Kzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)