UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cac55j8z2nOwvpn+/ICDBanSIA0vEzd3XPnxdffUDY0='
WHERE
key_id = 'd71878e4f6118176a3faeb8e261dcd1c7ccb769e30d4fb51a6d2c71d3906cc5a'
AND (
token = 'Cac55j8z2nOwvpn+/ICDBanSIA0vEzd3XPnxdffUDY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)