UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ot+fAFNEFam2mlwJqPo7r1KrPGIuzILiUpz++ng8Mw4='
WHERE
key_id = 'effc0f3000c9983cedc440107ac137d8213bca350a665f6a038531de6d67e286'
AND (
token = 'Ot+fAFNEFam2mlwJqPo7r1KrPGIuzILiUpz++ng8Mw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)