UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZCW2+65A2LcDab9livzC/zdSLqWqctW8L6G/VCVigI='
WHERE
key_id = '52866a79c53d07f7eaf78953f38421bbe4458048c8e88e68f1d8e7b8c28ab6f7'
AND (
token = 'XZCW2+65A2LcDab9livzC/zdSLqWqctW8L6G/VCVigI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)