UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXPlL95XdLiTyzjSmCc5+kNDhKXQoCSVYexfj5ItIfc='
WHERE
key_id = '5569e38af4633c198d4a48399112997d687658245a8f78697956df91aafc847d'
AND (
token = 'KXPlL95XdLiTyzjSmCc5+kNDhKXQoCSVYexfj5ItIfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)