UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HHrPlkpXcCJ64ffDEqPtRBSrbCIaELu0iCmIpqqwBw='
WHERE
key_id = '55738b62ef59f09b866e3ec14a5042993d8c3265f57aed10d7d12ec9d1f83652'
AND (
token = '0HHrPlkpXcCJ64ffDEqPtRBSrbCIaELu0iCmIpqqwBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)